package sopia.conn;

public class SQLQuery {
    public static final String KEY_NAME_ACCOUNT = "nameAccount";
    public static final String KEY_AMOUNT_ACCOUNT = "amountAccount";
    public static final String TAG = "DBAdapter";
    
    public static final String DATABASE_NAME = "Budget";
    
    public static final String DB_ACCOUNT_TABLE = "Account";
    public static final String DB_EXPENSIVE_TABLE = "Expensive";
    public static final String DB_CATEG0RY_TABLE = "Category";
    public static final String DB_ITEM_EXPENSIVE_TABLE = "ItemExpensive";
    
    public static final int DATABASE_VERSION = 1;
    
//	public static final String SQL_CREATE_ACCOUNT_TABLE =
//            "create table Account (_id integer primary key autoincrement, "
//            + "accountName text not null, amount text not null);";
	public static final String SQL_CREATE_ACCOUNT_TABLE = 
        " CREATE TABLE Account (nameAccount text NOT NULL PRIMARY KEY UNIQUE, " +
        "amountAccount decimal NOT NULL);";
	public static final String SQL_CREATE_EXPENSIVE_TABLE = 
        " CREATE TABLE Expensive (typeNameExp text NOT NULL PRIMARY KEY, " +
        "nameCategoryExp text NOT NULL,amountExp decimal NOT NULL,monthExp text NOT NULL);";
	public static final String SQL_CREATE_CATEGORY_TABLE = 
        " CREATE TABLE Category (nameCategory text NOT NULL PRIMARY KEY);";
	public static final String SQL_CREATE_ITEM_EXPENSIVE_TABLE = 
        " CREATE TABLE ItemExpensive (nameItemExp text NOT NULL PRIMARY KEY, " +
        "typeNameExpItemExp text NOT NULL,amountItemExp decimal NOT NULL, " +
        "dateItemExp date NOT NULL,commentItemExp text NOT NULL,nameAccountItemExp text NOT NULL);";
}
